In this lesson you need to help Little
Lemons set up their database project. There are three key steps
required to set up the project. Set up the database in MySQL Workbench
using a MySQL instance server. Create an entity relationship diagram and implemented in MySQL Workbench and
then commit the project. Over the next few minutes
you'll recap these topics and learn how you can make use
of them in the lesson. To help Little Lemon build their
relational database system, you'll first need to design a well structured
entity relationship data model or Diagram. You'll need to make sure that the diagram
conforms to the three fundamental normal forms. By conforming to these forms, you'll
ensure the integrity of your database and avoid the insertion update and
delete anomalies. As you've discovered in previous courses
there are many professional tools that you can use to design an Diagram. In this project you'll
work with MySQL Workbench, you should be familiar with
MySQL Workbench from other courses. So for
now let's just quickly recap the basics. MySQL Workbench is a unified visual tool
that's used for database modeling and data management. It's key advantages are that it's
open-source, cross platform and provide support for a visual SQL editor. It also lets you transform your data
model in a physical database schema in a MySQL server. If you haven't already installed
MySQL Workbench on your operating system, then you can download and install
a copy from dev.mysql.com/downloads. Once you've downloaded a copy of
MySQL Workbench run the installer file and make sure to install the following. MySQL server,
MySQL Workbench and MySQL Shell. The installation process is
relatively straightforward. However, if you do face any challenges, you can refer to the installation
material in the previous courses or visit the Oracle website for
a detailed set of instructions. Once you've created
the Little Lemon database, you then need to commit your project. You can commit a project using Git,
Git is a free, open source distributed
version control system. You can use it to manage
all source code history, you can keep a history of your commits
revert to previous versions and share code to collaborate
with other developers. You can download and install Git
from the URL, git-scm.com/downloads. Your Git repositories
are typically stored on GitHub. GitHub includes the source control
management features of Git along with other useful features. These features include project management,
support ticket management and bug tracking. You can also use it to share, access and
store repositories, including backups to sign up to GitHub and get started
visit the official site at github.com. Now that you're familiar with
the required technology, you can begin helping Little Lemon
to develop their database system. You can set up the database in
MySQL Workbench, create an Diagram and commit your model. If you need more information on any
of these topics then you can review the learning material
from previous courses. Good luck.